CREATE OR REPLACE PACKAGE cursors_pkg
IS
  TYPE refcursortype IS REF CURSOR;
  FUNCTION getproducts RETURN refcursortype;
END;
/

CREATE OR REPLACE PACKAGE BODY cursors_pkg
IS
  FUNCTION getproducts RETURN refcursortype
  IS allproductcursor refcursortype;
BEGIN
  OPEN allproductcursor FOR
    SELECT *
    FROM  BRND_MAS;
    RETURN allproductcursor;
  END;
END;